Search results for query: *

I’m looking for some assistance with a Power Automate flow. I need to upload a file to Jira from SharePoint. The document is initially saved in SharePoint from a Microsoft Forms submission. Here’s a brief overview of what I’m trying to achieve: A user submits a form via Microsoft Forms. The...

I need to build a comma-separated list with the data that is output from the formulas I've setup. There are 40 different groups (based on 40 different formulas) that people can fall into. Each person can be part of more than one group. I need to build a list summarizing the groups that they fell...

I am trying to get certain data from a row into a column. I would like to move a variable # of scholarships linked to one individual all to a single line item with multiple columns for each scholarship. It currently looks like this: Person_1 ID | Person_1 Name | Scholarship_1 ID | Scholarship...

I am trying to limit the outcome of my report that has 3 different data sources. Table 1. All individual contacts Table 2. Financial Report 1 Table 3. Financial Report 2 The tables can link on a common account number. I only want to pull individauls (Table 1) that have financial activity in...

Can someone help me build out a limit for payment terms on our website. I'd like to limit the number of installments that you can pay your balance in, depending on the date. Our year goes from 9/1/20XX - 8/31/20XX. If you sign up pre-September, you can choose UP TO 12 installments, anytime in...

I am building a report from a donation database that needs to include various benefit detail for each gift. I need to create a sentence from several multi-valued database fields that exist for the benefits. In the database, there could be multiple benefits for each gift-- each benefit would...

I feel like there is an obvious solution that I am missing, and I am hoping someone can help me out of this Monday rut! I have a report of donations to our organization for the year. I have the donations grouped by type and subtype, and I want to pull in the detailed donation information into...

I'm trying to match the value of a field in 'Column A' to any row of data in 'Column B', not just the fields corresponding row. Column A Column B Match? 1 6 Yes - "1" matches in row2 2 1 No - no match for 2 3 7 No- no...

I am struggling to write a conditional statement that would allow me to write a different sentence in one field based on several different fields, and potentially building that sentence. If the gift type is {Gift-in-Kind} then "Sentence about gift-in-kind." If the gift type is {Stock} then...

Hi, I want to move a field into a column at each change in [condition]. For each person in my data set, I want to put each of their memberships for the year in a new column. Basically, each person has a single row, even if they have multiple memberships. Each membership would become a new...

I am trying to build a custom receipt and I am having issues conditionally placing a note on the receipt. If customer made multiple transactions during a specified time period, I want all transactions to be on the receipt. If the department of any of the transactions is "XYZ," I want to add an...

I am trying to find a formula that will choose records based on if any object meets a certain criteria. Ex: Query pulls all customers with an outstanding balance; I want to include ONLY those customers that have also made an additional transaction since 3/1/2015, but the invoice should list ALL...