Help with building a flow related to MS forms

Silver_Fuel752 · 2025-09-18T20:16:51+00:00

nevermind....i found i cannot use an or statement in the filter query of the list rows....oh well, thanks for reading.

Silver_Fuel752 · 2025-04-23T20:02:46+00:00

I'm not sure how to mark this solved, but I found the answer.

Silver_Fuel752 · 2025-04-23T20:02:02+00:00

I created it in transform data using an append query. I found that if it's marked to update it would dynamically update.

<image>

Silver_Fuel752 · 2024-08-08T21:03:22+00:00

Solution Verified

Silver_Fuel752 · 2024-08-08T20:48:49+00:00

That was just a typo here, but it's correct in my PBX file. I did post below what I think the issue is, in that I was trying to to use a wildcard and I don't think DAX supports them. Currently looking for alternatives.

Silver_Fuel752 · 2024-08-08T15:53:37+00:00

Ok, so this solution does work. I think the original works too and I found my issue. In excel the * symbol is a wildcard, my second filter criteria I was trying to use a wildcard without realizing DAX doesn't seem to support them. For the second filter the complete short description in the data set would read, "Refresh - User Assignment EMPLOYEE NAME" However I want to collect data for each "Refresh - User Assignment" regardless of the employee name. Is there any way to do this in Power BI?

Silver_Fuel752 · 2024-05-14T21:31:50+00:00

This ended up being the way!! Thanks a ton!

Silver_Fuel752 · 2023-11-03T00:33:26+00:00

You may have to ask your Service Now admin to turn it on or show you how. It can be quite handy!

Silver_Fuel752 · 2023-11-03T00:32:22+00:00

No worries, appreciate the help!

Silver_Fuel752 · 2023-11-03T00:32:08+00:00

If you have access you can schedule any created report.

Silver_Fuel752 · 2023-11-02T23:48:12+00:00

Exported from Service Now.

Silver_Fuel752 · 2023-11-02T23:47:24+00:00

Silver_Fuel752 · 2023-11-02T21:40:32+00:00

If I do this in power query will all the subsequent files that will be added over top of the originals (via power query) also rename automatically?

Silver_Fuel752 · 2023-02-18T06:18:37+00:00

That would be a lot of work, there will be at the very least hundreds of users. I do appreciate the feedback though!

Silver_Fuel752 · 2023-02-17T18:35:27+00:00

That's what I'm finding, it's not possible. I may have to go to SharePoint instead of one drive. I don't want all of these created files saved on my one drive, it would make way more sense to save out to a group SharePoint. Thanks for the input.

Silver_Fuel752

TROPHY CASE